package cn.sh.yhk.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.mapping.StatementType;

@Mapper
public interface TUserExtendMapper {


    @Update("create table t_user11\n" +
            "(\n" +
            "    id          bigint                              not null comment '分布ID'\n" +
            "        primary key,\n" +
            "    user_id     int auto_increment comment '自增ID',\n" +
            "    name        varchar(64)                         null comment '名称',\n" +
            "    city_id     int(12)                             null comment '城市',\n" +
            "    sex         tinyint(1)                          null comment '性别',\n" +
            "    phone       varchar(32)                         null comment '电话',\n" +
            "    email       varchar(32)                         null comment '邮箱',\n" +
            "    create_time timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '创建时间',\n" +
            "    password    varchar(32)                         null comment '密码',\n" +
            "    constraint id\n" +
            "        unique (user_id)\n" +
            ")")
    @Options(statementType = StatementType.STATEMENT)
    void createTUserTable(String tableName);

    void createTUserTable1(@Param("tableName") String tableName);


}